Release 10.1A: OpenEdge Development:
Programming Interfaces

The CONTAINS operator, word indexes, and word-break tables

You can use the CONTAINS operator of the WHERE option of the record phrase to query a OpenEdge database. For example, the following query displays each item record of the sports database whose cat–description field contains the string “hockey”:

FOR EACH item WHERE cat-description CONTAINS "hockey":   DISPLAY item. END.

Using the CONTAINS operator involves word indexes and word-break tables. This section explains why and tells you how to use word indexes and word-break tables. Specifically, the section covers:

Understanding the CONTAINS operator, word indexes, and word-break tables.
Using word indexes.
Using word-break tables.
Using the CONTAINS operator.
Word indexing external documents.
Word indexing non-OpenEdge databases.
Note: Word indexes and word-break tables have international implications. To understand these implications, first read this section, then see the OpenEdge Development: Internationalizing Applications .